﻿<?php
	include ("../DB/Connect.php");

	$query = "drop table userInfo";
	if( !$db -> runSql( $query ) )
		echo $db -> error ."<br/>";
	
	$query = "create table userInfo ( name varchar(50) binary primary key, password varchar(50) binary, email varchar(50) binary, phone varchar(50) binary, birthday varchar(50) binary ,sex varchar(50) binary ,active bool ) ENGINE=InnoDB DEFAULT CHARSET=utf8;";
	if( !$db -> runSql( $query ) )
		echo $db -> error ."<br/>";

	$db -> close();
	
	echo "OK";
?>